package test.aat.pku;

import java.io.IOException;
import java.util.List;
import java.util.Map;

import com.aat.dxfy.utils.POIUtil;

public class En3 {
	public static void main(String[] args) {
		try {
			List<Map<Integer, String>> list=POIUtil.readExcelContent("D:\\en3.xls");
			//;
			for (Map<Integer, String> map : list) {
				System.out.println("update pku_dept_score set en3Flag='三级',en3LotNum='"+map.get(1)+"',en3Score="+map.get(2)+" where num='"+map.get(0)+"';");
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
}
